select * from products where pro_name like '%ball%gown%' or pro_des like '%ball%gown%'union all select * from products where (pro_name like '%ball%' or pro_des like '%ball%') or(pro_name like '%gown%' or pro_des like '%gown%') and (pro_name not like '%ball%gown%' or pro_des not like '%ball%gown%')

Taffeta One Shoulder Royal Blue Dama Quinceanera Dress with Pleat

V-neck Aqua Blue Floor-length Dama Gown With Pleat in Chiffon

Column Strapless Dama Dress in Lilac with Belt and Ruches

White and Hot Pink A-line Straps Mini-length Quince Dama Dresses

Orange Empire V-neck Knee-length Chiffon Ruch Party Dama Dresses

Olive Green Mini-length Sweetheart Cocktail Dresses For Dama Pleated

Elegant Strapless Quinceanera Dress with Beading and Appliques

Fabulous Light Blue Strapless Beading Quinceanera Dresses Gowns

Magnificent Hot Pink Strapless Ruching Appliques Quinceanera Dress

Fashionable Quinceanera Gowns Dresses with Beading and Pick-ups

Ruffles Sweetheart Beaded Fuchsia Quinceanera Gowns of Sweet 16

Baby Pink Sweetheart Quinceanera Gown with Appliques and Overskirt

Popular Purple Sweet Sixteen Dresses with Embroidery and Pick-ups

Custom Made Strapless Embroidery Quinceanera Dress with Overskirt

Exquisite Halter Embroidered Olive Green Dress for Quinceaneras

Unique Lavender Sweetheart Quinceanera Gowns with Appliques

Olive Green Sweetheart Organza Beading and Ruffle Dresses 15

Wonderful Spring Green Paillette Sweet 16 Dress with Appliques

Modest Purple Sweetheart Appliques Quinceanera Gown with Jacket

Princess Off the Shoulder Prom Dress with Appliques in Organza

Ruffled and Ruched Quinces Gown For Military Ball with Appliques

Taffeta and Tulle Quince Dress in Teal and White with Floor-length

Multi-color Sweetheart Sweet 15th Dress with Ruffles and Appliques

White and Olive Green Ball Gown Quince Dress in Taffeta and Tulle

Ball Gown Dress Quinces with Embroidery in White and Turquoise

Floor-length Strapless Dress for Sweet Sixteenth with Embroidery

Sweetheart Beaded Quinces Dress in Light Blue with Tulle Fabric

Green and Black Quinceanera Dress with V-neck Straps and Beading

Lilac Quinceanera Gown with Organza Ruffles and Appliques

Strapless Quinces Dress with Ruffles and Appliques in Coral Red